﻿CREATE PROCEDURE [dbo].[Hogar_Remito_ObtenerTodos]   
AS 
BEGIN

/*****************************************************************************************************************************************/
-- Author: Carlos Mendoza
-- Purpose:   obtener todos los remitos
-- Returns:    ConsultaRemito
/*****************************************************************************************************************************************/ 
	
	SELECT  [RemitoId],
			[NumeroRemito],
			[FechaEntrega],
			ISNULL([Observacion],'') AS [Observacion],
			r.[ProveedorId],
			p.[Nombre] AS [Proveedor]
	FROM	[dbo].[Remito] r WITH (NOLOCK)
	INNER JOIN [dbo].[Proveedor] p WITH (NOLOCK) ON r.ProveedorId = p.ProveedorId
	ORDER BY [NumeroRemito]
	
END